package JDBC;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;


public class JDBCDemo12 {
    public static void main(String[] args) {
        try (Connection connection=DBUtil.getConnection();){
            connection.setAutoCommit(false);
            connection.setTransactionIsolation(connection.TRANSACTION_READ_UNCOMMITTED);

            String sql="INSERT INTO userinfo(username,password,nickname,age) " +
                    " VALUES(?,?,?,?) ";
            PreparedStatement ps=connection.prepareStatement(sql);
                    ps.setString(1,"王五");
                    ps.setString(2,"123456");
                    ps.setString(3,"老五");
                    ps.setInt(4,18);

                    int num=ps.executeUpdate();

            System.out.println(num>0?"添加成功":"添加失败");
            connection.commit();















        } catch (SQLException e) {
            throw new RuntimeException(e);
        }


    }
}
